package com.letv.core.constant;



/**
 * 应用程序数据库中的表名，字段名等信息
 * @author 吴新荣
 */

public class DatabaseConstant {
    
        /**
         * 搜索记录表
         * 
         */
        public static class SearchTrace {

            /**
             * 表名
             */
            public static final String TABLE_NAME = "searchtable";

            public static class Field {

                /**
                 * 搜索关键字
                 */
                public static final String NAME = "name";
                /**
                 * 搜索时间戳
                 */
                public static final String TIMESTAMP = "timestamp";

            }
        }

        /**
         * 初始化频道收藏表
         * 
         */
        public static class ChannelListTrace {

            public static final String TABLE_NAME = "channellisttable";

            public static class ChannelStatus {
                public static final String NORMAL = "normal";
                public static final String DELETE = "delete";
            }

            public static class Field {
                /**
                 * 频道ID
                 * 
                 */
                public static final String CHANNELID = "channelid";

                /**
                 * 数字键
                 */
                public static final String NUMERICKEYS = "numericKeys";
                /**
                 * 频道名称
                 */
                public static final String NAME = "name";
                /**
                 * 频道ename
                 */
                public static final String ENAME = "ename";
                /**
                 * 频道上线开始时间 如："2012-09-01 20:24:37"
                 * 此字段可以用作频道的上线时间，前端根据此字段来判断频道是否是新频道。
                 */
                public static final String BEGINTIME = "beginTime";

                /**
                 * 频道下线结束时间，为空表示频道一直启用
                 */
                public static final String ENDTIME = "endTime";
                /**
                 * 频道分类，参考词典《频道分类编码》
                 */
                public static final String CHANNELCLASS = "channelClass";
                /**
                 * 频道所属品牌，参考《频道所属品牌信息获取接口》
                 */
                public static final String BELONGBRAND = "belongBrand";
                /**
                 * 信号源，参考词典《信号源编码》
                 */
                public static final String SOURCEID = "sourceId";

                /**
                 * 是否为3D频道（1是 0否）
                 */
                public static final String IS3D = "is3D";

                /**
                 * 是否为4K频道（0 否 1 4K 2 伪4K）
                 */
                public static final String IS4K = "is4K";

                /**
                 * 渠道号
                 */
                public static final String CH = "ch";

                /**
                 * 序号，客户端排序用
                 * 是否可空：是
                 */
                public static final String ORDERNO = "orderNo";

                /**
                 * 是否推荐 （1 是 0 否）
                 */
                public static final String ISCOMMEND = "isRecommend";

                /**
                 * 频道LOGO竖图 120*90
                 */
                public static final String LOGO120X90 = "logo120x90";

                /**
                 * 频道LOGO原图
                 */
                public static final String LOGOORIGIN = "logoOrigin";

                /**
                 * 频道LOGO横图150*200
                 */
                public static final String LOGO150X200 = "logo150x200";

                /**
                 * 频道LOGO横图120*160
                 */
                public static final String LOGO120X160 = "logo120x160";

                /**
                 * 频道LOGO横图96*128
                 */
                public static final String LOGO96X128 = "logo96x128";

                /**
                 * 频道LOGO横图150*150
                 */
                public static final String LOGO150X150 = "logo150x150";

                /**
                 * 频道LOGO横图30*30
                 */
                public static final String LOGO30X30 = "logo30x30";
                /**
                 * 是否已保存
                 */
                public static final String HASSAVE = "hassave";
                /**
                 * 当前频道的状态
                 */
                public static final String CHANNELSTATUS = "channelstatus";

                public static final String CHANNEL_TYPE = "channel_type";
            }
        }

        /**
         * 初始化频道收藏表
         * 
         */
        public static class ChannelHisListTrace {

            public static final String TABLE_NAME = "channelhislisttable";

            public static class ChannelStatus {
                public static final String NORMAL = "normal";
                public static final String DELETE = "delete";
            }

            public interface ChannelType {

                String TYPE_LUNBO = PlayConstant.CHANNEL_TYPE_VALUE_LUNBO;

                String TYPE_WEISHI = PlayConstant.CHANNEL_TYPE_VALUE_WEISHI;
            }

            public static class Field {
                /**
                 * 频道ID
                 * 
                 */
                public static final String CHANNELID = "channelid";

                /**
                 * 数字键
                 */
                public static final String NUMERICKEYS = "numericKeys";
                /**
                 * 频道名称
                 */
                public static final String NAME = "name";
                /**
                 * 频道ename
                 */
                public static final String ENAME = "ename";
                /**
                 * 频道上线开始时间 如："2012-09-01 20:24:37"
                 * 此字段可以用作频道的上线时间，前端根据此字段来判断频道是否是新频道。
                 */
                public static final String BEGINTIME = "beginTime";

                /**
                 * 频道下线结束时间，为空表示频道一直启用
                 */
                public static final String ENDTIME = "endTime";
                /**
                 * 频道分类，参考词典《频道分类编码》
                 */
                public static final String CHANNELCLASS = "channelClass";
                /**
                 * 频道所属品牌，参考《频道所属品牌信息获取接口》
                 */
                public static final String BELONGBRAND = "belongBrand";
                /**
                 * 信号源，参考词典《信号源编码》
                 */
                public static final String SOURCEID = "sourceId";

                /**
                 * 是否为3D频道（1是 0否）
                 */
                public static final String IS3D = "is3D";

                /**
                 * 是否为4K频道（0 否 1 4K 2 伪4K）
                 */
                public static final String IS4K = "is4K";

                /**
                 * 渠道号
                 */
                public static final String CH = "ch";

                /**
                 * 序号，客户端排序用
                 * 是否可空：是
                 */
                public static final String ORDERNO = "orderNo";

                /**
                 * 是否推荐 （1 是 0 否）
                 */
                public static final String ISCOMMEND = "isRecommend";

                /**
                 * 频道LOGO竖图 120*90
                 */
                public static final String LOGO120X90 = "logo120x90";

                /**
                 * 频道LOGO原图
                 */
                public static final String LOGOORIGIN = "logoOrigin";

                /**
                 * 频道LOGO横图150*200
                 */
                public static final String LOGO150X200 = "logo150x200";

                /**
                 * 频道LOGO横图120*160
                 */
                public static final String LOGO120X160 = "logo120x160";

                /**
                 * 频道LOGO横图96*128
                 */
                public static final String LOGO96X128 = "logo96x128";

                /**
                 * 频道LOGO横图150*150
                 */
                public static final String LOGO150X150 = "logo150x150";

                /**
                 * 频道LOGO横图30*30
                 */
                public static final String LOGO30X30 = "logo30x30";
                /**
                 * 是否标记为收藏的历史
                 */
                public static final String ISRECORD = "isRecord";
                /**
                 * 系统毫秒值
                 */
                public static final String SYSTEMILLISECOND = "systemmillisecond";
                /**
                 * 当前频道的状态
                 */
                public static final String CHANNELSTATUS = "channelstatus";

                public static final String CHANNEL_TYPE = "channel_type";
            }
        }

        /**
         * 初始化时节日祝福表
         * 
         * @author ddf
         * 
         */
        public static class FestivalImageTrace {

            /**
             * 表名
             */
            public static final String TABLE_NAME = "festivalimagetrace";

            public static class Field {

                /**
                 * string ,name
                 */
                public static final String NAME = "name";

                /**
                 * string ,name
                 */
                public static final String PIC = "pic";
                /**
                 * long,start time
                 */
                public static final String START_TIME = "starttime";
                /**
                 * long ,end time
                 */
                public static final String END_TIME = "endtime";

                /**
                 * boolean , is top
                 */
                public static final String ORDER = "orderk";

            }

        }

        /**
         * 下载记录表，包括未完成和已完成
         * 
         * @author ddf
         * 
         */
        public static class DownloadTrace {

            /**
             * 表名
             */
            public static final String TABLE_NAME = "downlaodTrace";

            public static class Field {

                public static final String ALBUM_ID = "albumId";

                public static final String CID = "cid";

                public static final String ORDER = "ord";

                public static final String ICON = "icon";

                public static final String TYPE = "type";

                public static final String EPISODE_ID = "episodeid";

                public static final String EPISODE_TITLE = "episodetitle";

                public static final String EPISODE_ICON = "episodeicon";

                public static final String ALBUM_TITLE = "albumtitle";

                public static final String TOTAL_SIZE = "totalsize";

                public static final String FINISH = "finish";

                public static final String TIMESTAMP = "timestamp";

                public static final String LENGTH = "length";
                public static final String VIDEO_TYPE_KEY = "video_type_key";

                /**
                 * 3.7 add 下载路径
                 */
                public static final String FILE_PATH = "file_path";
                /**
                 * 4.1 add 是否是高清
                 * */
                public static final String ISHD = "isHd";
                /**
                 * 5.0添加 区分是 之前版本数据 还是 最新数据 旧数据 默认为 0， 新数据为 1
                 */
                public static final String IS_NEW = "isNew";

                /**
                 * 片头时间
                 */
                public static final String B_TIME = "btime";
                /**
                 * 片尾时间
                 */
                public static final String E_TIME = "etime";

                /**
                 * 下载完成之后，用户是否观看
                 */
                public static final String IS_WATCH = "isWatch";

                /**
                 * 时长
                 */
                public static final String DURATION = "duration";
            }
        }

        /**
         * 播放记录表
         * 
         * @author ddf
         */

        public static class PlayRecord {
            /**
             * 表名
             */
            public static final String TABLE_NAME = "playtable";

            public static class Field {
                /**
                 * 频道ID
                 * */
                public static final String CID = "cid";
                /**
                 * 专辑ID
                 * */
                public static final String PID = "pid";
                /**
                 * 视频ID
                 * */
                public static final String VID = "vid";
                /**
                 * 下一集视频ID
                 * */
                public static final String NVID = "nvid";
                /**
                 * 用户ID
                 * */
                public static final String UID = "uid";
                /**
                 * 视频类型
                 * */
                public static final String VTYPE = "vtype";
                /**
                 * 来源
                 * */
                public static final String FROM = "playtracefrom";
                /**
                 * 视频总时长
                 * */
                public static final String VTIME = "vtime";
                /**
                 * 播放时间点
                 * */
                public static final String HTIME = "htime";
                /**
                 * 最后更新时间
                 * */
                public static final String UTIME = "utime";
                /**
                 * 视频标题
                 * */
                public static final String TITLE = "title";
                /**
                 * 视频封面图
                 * */
                public static final String IMG = "img";
                /**
                 * 当前集数
                 */
                public static final String NC = "nc";
                /**
                 * 该条信息状态 0 默认状态，无修改，1更新待上传，2删除待上传
                 * */
                public static final String STATE = "state";
                /**
                 * 视频类型
                 * */
                public static final String TYPE = "type";
                /**
                 * 视频封面图300
                 * */
                public static final String IMG300 = "img300";
                /**
                 * 视频类型 正片 预告片 花絮 片花
                 * */
                public static final String VIDEOTYPEKEY = "videotypekey";
            }
        }

        /**
         * 专辑中某集视频是否已看过
         * 
         * @author chenhong
         */
        public static class PlayRecordWatched {
            /**
             * 表名
             */
            public static final String TABLE_NAME = "playtablewatched";

            public static class Field {
                /**
                 * 专辑ID
                 * */
                public static final String PID = "pid";
                /**
                 * 视频ID
                 * */
                public static final String VID = "vid";
            }
        }

        /**
         * 收藏记录表
         * 
         * @author ddf
         * 
         */
        public static class FavoriteRecord {

            /**
             * 表名
             */
            public static final String TABLE_NAME = "Favoritetable";

            public static class Field {

                /**
                 * 搜索时间戳
                 */
                public static final String TIMESTAMP = "timestamp";

                public static final String ID = "id";

                public static final String AID = "aid";

                public static final String TITLE = "title";

                public static final String SUBTITLE = "subTitle";

                public static final String ICON = "icon";

                public static final String SCORE = "score";

                public static final String CID = "cid";

                public static final String YEAR = "year";

                public static final String COUNT = "count";

                public static final String TIMELENGTH = "timeLength";

                public static final String DIRECTOR = "director";

                public static final String ACTOR = "actor";

                public static final String AREA = "area";

                public static final String SUBCATE = "subcate";

                public static final String RCOMPANY = "rcompany";

                public static final String CTIME = "ctime";

                public static final String TYPE = "type";

                public static final String ALBUMTYPE = "albumtype";

                public static final String AT = "at";

                public static final String SINGLEPRICE = "singleprice";

                public static final String ALLOWMONTH = "allowmonth";

                public static final String PAYDATE = "paydate";

                public static final String NEEDJUMP = "needJump";

                public static final String PAY = "pay";

                public static final String ISDOLBY = "isDolby";
                public static final String ISEND = "isEnd";
                public static final String EPISODE = "episode";
            }
        }

        /**
         * 本地视频
         * 
         * @author liuheyuan
         * 
         */
        public static class LocalVideoTrace {

            public static final String TABLE_NAME = "LocalVideoTable";

            public static class Field {

                public static final String PATH = "c_path";

                public static final String TITLE = "c_title";

                public static final String POSITION = "c_position";

                public static final String FILESIZE = "c_filesize";

                public static final String TIMELENGTH = "c_timelength";

                public static final String CREATETIME = "c_createtime";

                public static final String VIDEO_W_H = "c_video_w_h";

                public static final String VIDEO_TYPE = "c_video_type";

            }
        }

        /**
         * 本地视频
         * 
         * @author liuheyuan
         * 
         */
        public static class LiveBookTrace {

            public static final String TABLE_NAME = "LiveBookTrace";

            public static class Field {

                /**
                 * 直播节目名称
                 */
                public static final String MD5_ID = "md5";

                /**
                 * 直播节目名称
                 */
                public static final String PROGRAMNAME = "programName";

                /**
                 * 直播频道名称
                 */
                public static final String CHANNELNAME = "channelName";

                /**
                 * 直播频道编码
                 */
                public static final String CODE = "code";

                /**
                 * 直播节目开播时间
                 */
                public static final String PLAY_TIME = "play_time";

                /**
                 * 直播节目开播时间
                 */
                public static final String PLAY_TIME_LONG = "play_time_long";

                /**
                 * 是否推送过
                 */
                public static final String IS_NOTIFY = "is_notify";

                public static final String LAUNCH_MODE = "launch_mode";
                public static final String LIVE_ID = "live_id";

            }
        }

        /**
         * 客户端提示语服务端化
         * 
         * @author haitian
         * 
         */
        public static class DialogMsgTrace {

            public static final String TABLE_NAME = "DialogMsgTrace";

            public static class Field {
                public static final String MSGID = "msgId";
                public static final String MAGTITLE = "msgTitle";
                public static final String MESSAGE = "message";

            }
        }

        /**
         * 客户端提示语服务端化
         * 
         * @author haitian
         * 
         */
        public static class LocalCacheTrace {

            public static final String TABLE_NAME = "LocalCacherace";

            public static class Field {
                public static final String CACHEID = "cacheId";
                public static final String ASSISTKEY = "assistkey";
                public static final String MARKID = "markid";
                public static final String CACHEDATA = "cachedata";
                public static final String CACHETIME = "cachetime";

            }
        }

        /**
         * 顶级频道记录
         */
        public static class TopChannelsTrace {

            public static final String TABLE_NAME = "TopChannelsTrace";

            public static class Field {
                public static final String CHANNELID = "channelId";
                public static final String CHANNELNAME = "channelName";
                public static final String CHANNELTYPE = "channelType";
                public static final String ORDER = "orderk";
            }
        }

        /**
         * 世界杯口袋看球下载记录表（v5.4.1）
         * 
         * @author ljnalex
         */
        public static class WorldCupTrace {

            /**
             * 表名
             */
            public static final String TABLE_NAME = "worldCupTrace";

            public static class Field {

                /**
                 * 预留，可能为空
                 */
                public static final String ALBUM_ID = "albumId";

                public static final String CID = "cid";

                public static final String ORDER = "ord";

                public static final String ICON = "icon";

                public static final String TYPE = "type";

                public static final String EPISODE_ID = "episodeid";

                public static final String EPISODE_TITLE = "episodetitle";

                public static final String EPISODE_ICON = "episodeicon";

                public static final String ALBUM_TITLE = "albumtitle";

                public static final String TOTAL_SIZE = "totalsize";

                public static final String FINISH = "finish";

                public static final String TIMESTAMP = "timestamp";

                public static final String LENGTH = "length";

                public static final String FILE_PATH = "file_path";

                public static final String ISHD = "isHd";

                /**
                 * 片头时间
                 */
                public static final String B_TIME = "btime";

                /**
                 * 片尾时间
                 */
                public static final String E_TIME = "etime";
            }
        }
}